Release 10.1A: OpenEdge Data Management:
Database Administration

PROMON Locking and Waiting statistics option

Displays lock and wait information for each database process. The first two lines display cumulative statistics (since the broker started) for all users. Figure 19–3 shows an example of this option’s output.

Locking and Waiting: Type Usr Name Record Trans Schema Lock 999 TOTAL...         2345          567          145 Wait 999 TOTAL...           89           12            9 Lock   0                   654           32           33 Wait   0                     0            0            0 Lock   1 sue                54            6            3 Wait   1 sue                 0            0            0 Lock   2 dave               43            7            2 Wait   2 dave               21            3            2 Lock   3                  1123          302           54 Wait   3                    12            1            0 Lock   4 mary              345           89           30 Wait   4 mary               20            6            0 Lock   5 bill              101           20           15 Wait   5 bill               10            2            0 Lock   6                   175           34            0 Wait   6                    15            3            0 RETURN - show remaining, U - continue uninterrupted, Q - quit:

Figure 19–3: Sample output for PROMON Locking and Waiting statistics option

Type

Lock or Wait. The output display includes two lines for each process. The first shows the number of record, transaction, and schema locks obtained, and the second shows the number of times the process waited to obtain one of these locks.

Usr

The user number of the process. User number 999 represents all users.

Name

For client processes, the user name.

Record

For the Lock type, the total number of record locks obtained. For the Wait type, the number of times the user had to wait to obtain a record lock. Numbers are cumulative for the life of the process.

Trans

For the Lock type, the number of times a transaction lock was issued. A transaction lock is issued for the duration of a transaction when a record is deleted. If the transaction is ultimately undone or backed out, the record is not deleted.

For the Wait type, the number of times the user had to wait before accessing or skipping a record marked for deletion by an unfinished transaction. This transaction wait corresponds exactly to the TSK wait described under User Control (option 1).

Schema

For the Lock type, the total number of times the schema lock was obtained. For the Wait type, the number of times the user had to wait to obtain the schema lock. (There is one schema lock; only one user at a time can update any part of the schema.)